from sqlalchemy.dialects.mysql import INTEGER, VARCHAR,FLOAT,DOUBLE
from sqlalchemy import Column
from sqlalchemy.ext.declarative import declarative_base
from pydantic import BaseModel


Base = declarative_base()


class GroundColliery(Base):
    __tablename__ = 'downhole_colliery'
    id = Column(INTEGER, primary_key=True)
    identifier = Column(VARCHAR(255), nullable=False)
    create_time = Column(INTEGER, default=0)
    update_time = Column(INTEGER, default=0)


class FormBody(BaseModel):
    identifier:str



class EditBody(BaseModel):
    colliery_id:int
    identifier:str
